ack! query failed:
errorno=1064error=You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'and
tp.categoryID= and tc.categoryID=ts.categoryID
andquery=select distinct(productID) ,productName, con.companyID as 'companyid', companyName,
productDescription, productPrice, fileSize, plateformOS, tp.registerDate, totalDownload
from tblproductmaster tp, tblcategorymaster tc, tblcompanymaster con,
tblsubcategorymaster ts where tp.oldSubCategoryID= and
tp.categoryID= and tc.categoryID=ts.categoryID
and ts.oldSubCategoryID=tp.oldSubCategoryID and ts.categoryID=tc.categoryID
and con.companyID=tp.companyID and tp.status='1'
AND FIND_IN_SET('1',tp.osSupported)